﻿USE KWR
GO

CREATE TABLE [dbo].[Transformations]
(
	Id int NOT NULL Identity(1,1), 
	Kwrid int not null,
	a decimal(6,4) not null,
	b decimal(6,4) not null,
	c decimal(6,4) not null,
	d decimal(6,4) not null,
	e decimal(6,4) not null,
	f decimal(6,4) not null
) on [primary]
go

ALTER TABLE dbo.[Transformations] ADD CONSTRAINT
	pk_Transformations PRIMARY KEY CLUSTERED 
	(
	id
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
go

ALTER TABLE dbo.Transformations ADD CONSTRAINT
	FK_Transformations_KwrNames FOREIGN KEY
	(
	Kwrid
	) REFERENCES dbo.KwrNames
	(
	id
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO

